// 配送区域
const {DataTypes, db } = require("../db");
db.define('psCargoTemp', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:'租户ID'}, 
uuid:{type: DataTypes.STRING(128),comment:'票号'},
billNo:{type: DataTypes.STRING(20),comment:'票号'},
billDate:{type: DataTypes.STRING(10),comment:'票据日期'},
buName:{type: DataTypes.STRING(100),comment:'送货员'},
address:{type: DataTypes.STRING(255),comment:'送货员'},
    invName:{type: DataTypes.STRING(255),comment:'送货员'},
    spec:{type: DataTypes.STRING(255),comment:'送货员'},
unit:{type: DataTypes.STRING(255),comment:'送货员'},
qty:{type: DataTypes.FLOAT,comment:'送货员'},
price:{type: DataTypes.FLOAT,comment:'送货员'},
disAmount:{type: DataTypes.FLOAT,comment:'送货员'},
amount:{type: DataTypes.FLOAT,comment:'送货员'},
remark:{type: DataTypes.STRING(255),comment:'送货员'},
specInt:{type: DataTypes.INTEGER,comment:'送货员'},
calNum:{type: DataTypes.INTEGER,comment:'送货员'},
unit1:{type: DataTypes.STRING(10),comment:'送货员'},
unit2:{type: DataTypes.STRING(10),comment:'送货员'},


}, {
    tableName: 'ps_cargo_temp',
    timestamps: false,
    comment: '配送表临时',
});